package com.qqqq.service;

import com.qqqq.core.Page;
import com.qqqq.domain.SignIn;
import com.qqqq.domain.Student;

import java.sql.SQLException;

public interface StudentService {
    /**
     * @param stuNumber 学号
     * @param password  密码
     * @return 登录成功的用户
     */
    Student login(int stuNumber, String password) throws SQLException;

    int addStudentSign(int id) throws SQLException;

    Page<SignIn> pageSignIn(int stuId, int pageNum, int pageSize) throws SQLException;

    int addStudent(Student student) throws SQLException;

    Student getStudent(int id) throws SQLException;

    int updateStudent(Student student) throws SQLException;

    int deleteStudent(int id) throws SQLException;

    Page<Student> pageStudent(Integer stuMajorId, Integer stuClassId, int pageNum, int pageSize) throws SQLException;
}
